--------------------------------------------------------
--  DDL for Table ACCOUNT_INFO
--------------------------------------------------------
  CREATE TABLE "ACCOUNT_INFO" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"USER_NAME" VARCHAR2(256 BYTE), 
	"FIRST_NAME" VARCHAR2(128 BYTE), 
	"LAST_NAME" VARCHAR2(128 BYTE), 
	"MOBILE_ALIAS" VARCHAR2(16 BYTE), 
	"MOBILE_PIN" VARCHAR2(16 BYTE), 
	"EMAIL" VARCHAR2(256 BYTE), 
	"IS_ANONYMOUS" VARCHAR2(1 BYTE), 
	"IS_APPROVED" VARCHAR2(1 BYTE), 
	"IS_LOCKEDOUT" VARCHAR2(1 BYTE), 
	"CREATE_UTC_DATE" DATE, 
	"FAILED_PASSWORD_ATTEMPT_COUNT" NUMBER(*,0), 
	"FAILED_PASSWORD_ATTEMPT_DATE" DATE, 
	"FAILED_ANSWER_ATTEMPT_COUNT" NUMBER(*,0), 
	"FAILED_ANSWER_ATTEMPT_DATE" DATE, 
	"PASSWORD_EXPIRATION_UTC_DATE" DATE, 
	"IS_DELETED" VARCHAR2(1 BYTE), 
	"CAN_CONTACT_BY_EMAIL" VARCHAR2(1 BYTE), 
	"IS_SUSPENDED" VARCHAR2(1 BYTE), 
	"LAST_PASSWORD_CHANGED_DATE" DATE
   )  ;
--------------------------------------------------------
--  DDL for Index ACCOUNT_INFO_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "ACCOUNT_INFO_PK" ON "ACCOUNT_INFO" ("APPLICATION_KEY", "USER_NAME")  ;
--------------------------------------------------------
--  Constraints for Table ACCOUNT_INFO
--------------------------------------------------------
  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "ACCOUNT_INFO_PK" PRIMARY KEY ("APPLICATION_KEY", "USER_NAME");
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_DELETED" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_ANSWER_ATTEMPT_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_ANSWER_ATTEMPT_COUNT" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_PASSWORD_ATTEMPT_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_PASSWORD_ATTEMPT_COUNT" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("CREATE_UTC_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_LOCKEDOUT" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_APPROVED" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_ANONYMOUS" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
